﻿using Microsoft.EntityFrameworkCore.Metadata.Internal;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations.Schema;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Collections;

namespace XinjeMesProgram.Models
{
    /// <summary>
    /// 物料追踪表（数据）
    /// </summary>
    public class MaterialDataModel //表格数据
    {
        /// <summary>
        /// 唯一Id
        /// </summary>
        public string? Id { get; set; }

        /// <summary>
        /// 文件编号
        /// </summary>
        public string? Documentnumbern { get; set; }

        /// <summary>
        /// 分析专员
        /// </summary>
        public string? Analyst { get; set; }

        /// <summary>
        /// ECN编号
        /// </summary>
        public string? Number { get; set; }

        /// <summary>
        /// ECN发布时间
        /// </summary>
        public string? ReleaseTime { get; set; }

        /// <summary>
        /// 变更内容
        public string? ChangeContent { get; set; }

        /// <summary>
        /// 变更原因
        /// </summary>
        public string? ReasonForChange { get; set; }

        /// <summary>
        /// 工单
        /// </summary>
        public string? WorkOrder { get; set; }

        /// <summary>
        /// 工单完成日期
        /// </summary>
        public string? WorkOrderCompletionDate { get; set; }

        /// <summary>
        /// 序列号段
        /// </summary>
        public string? SerialNumber { get; set; }

        /// <summary>
        /// 序列号段（起始）
        /// </summary>
        public string? SerialNumber1 { get; set; }

        /// <summary>
        /// 序列号段（结束）
        /// </summary>
        public string? SerialNumber2 { get; set; }

        /// <summary>
        /// 产品代码
        /// </summary>
        public string? ProductionCode { get; set; }

        /// <summary>
        /// 产品型号
        /// </summary>
        public string? ProductModel { get; set; }

        /// <summary>
        /// 跟踪物料代码
        /// </summary>
        public string? TrackMaterialCode { get; set; }
        

        /// <summary>
        /// 跟踪物料名称
        /// </summary>
        public string? TrackingMaterialName { get; set; }

        /// <summary>
        /// 跟踪物料型号
        /// </summary>
        public string? TrackMaterialModel { get; set; }

        /// <summary>
        /// 位号
        /// </summary>
        public string? BitNumber { get; set; }

        /// <summary>
        /// 生产数量
        /// </summary>
        public string? ProductionQuantity { get; set; }

        /// <summary>
        /// 在库数量
        /// </summary>
        public string? QuantityInStock { get; set; }

        /// <summary>
        /// 不在库数量
        /// </summary>
        public string? NotInStockQuantity { get; set; }

        /// <summary>
        /// 跟踪月份（3、6、9、12）
        /// </summary>
        public string? EndDate { get; set; }

        /// <summary>
        /// 故障数
        /// </summary>
        public string? FaultNumber { get; set; }

        /// <summary>
        /// 故障率
        /// </summary>
        public string? MaintenanceNumber { get; set; }

        /// <summary>
        /// 备注  
        /// </summary>
        public string? Remarks { get; set; }

        /// <summary>
        /// 是否异常， 0：正常 1：待核对 2：异常
        /// </summary>
        public int? Abnormal { get; set; }

        /// <summary>
        /// 生产部门
        /// </summary>
        public string? Product_category { get; set; }
    }
}
